This readme provides an overview of replication files for "The Price of Inclusion: Evidence from Housing Developer Behavior."

Evan Soltas
Last updated: 8 June 2022

Analysis done on a Macbook Pro (late 2016 edition) in StataSE 16

* Code file notes

	- To reproduce a given table/figure in the paper or appendices, run the code file in the code/analysis folder with the correspondingly named table or figure.

	- To compile the data from the raw data files, run code/clean/master.do. Note this file will take a long time to run. The master.do file also provides a useful overview of the files which prepare the main analysis dataset, all in the code/clean folder.

	- The code/modules subfolder provides code files used both in data preparation and analysis, such as the Hendren & Sprung-Keyser QJE code base or my NYC property tax calculator.

	- The code/scrape subfolder provides code files needed to scrape the raw data as well as spatial merge code for the IHP/NPP and geocoding tools. Note: Since producing this paper, NYC Department of Finance has made it more difficult to scrape the property tax bills. The original scraping code will likely have to be modified to re-scrape the relevant data.

	- The tables folder contains the raw estimates, templates for all tables, and the output of the tables appearing in the paper.

	- The figs folder contains all figures in the paper.

* Data file sources

	- assessments folder: NYC Department of Finance, via NYC OpenData (https://data.cityofnewyork.us/Housing-Development/Property-Valuation-and-Assessment-Data/rgy2-tti8)

	- CensusAreaCharacteristics folder: US Census, via Social Explorer (socialexplorer.com)

	- DOB_Permit_Issuance.csv: NYC Department of Buildings, via NYC OpenData (https://data.cityofnewyork.us/Housing-Development/DOB-Permit-Issuance/ipu4-2q9a)

	- error_files/old_bbls_to_drop.dta: manual review of cleaned_data.dta for PLUTO records where original construction is old despite "NB" permit in sample

	- error_files/patch_ct2010_missing.dta: manual review of cleaned_data.dta for missing Census tracts 

	- error_files/pluto_data_errors.dta: manual review of cleaned_data.dta for outliers, crosschecking against NYC records

	- GIS_boundaries/cty_boundaries: US Department of Transportation, via https://catalog.data.gov/dataset/county-boundaries-with-shorelines-national

	- GIS_boundaries/ihp: NYC Department of Housing Preservation & Development, via NYC OpenData: https://data.cityofnewyork.us/Housing-Development/Inclusionary-Housing-Properties/cm6g-t7ye 

	- GIS_boundaries/liberty_zone: Manually compiled from definition, see appendix

	- GIS_boundaries/neighborhood_boundaries: NYC Department of City Planning, https://www1.nyc.gov/site/planning/data-maps/open-data/census-download-metadata.page

	- GIS_boundaries/npp: Manually compiled, see appendix

	- GIS_boundaries/tract_boundaries: US Census TIGER, via https://www2.census.gov/geo/tiger/TIGER2016/TRACT/

	- GEA folder: NYC Department of Housing Preservation & Development, https://www1.nyc.gov/site/hpd/services-and-information/tax-incentives-421-a.page (see "How to Apply")

	- HousingCostDistrib folder: American Community Survey microdata 

	- nyc_pluto_19v2_csv: NYC Department of City Planning, via https://www1.nyc.gov/site/planning/data-maps/open-data/dwn-pluto-mappluto.page

	- OtherHousingAssistance/LIHTC folder: US Department of Housing and Urban Development, via https://www.huduser.gov/portal/datasets/lihtc/property.html

	- OtherHousingAssistance/NYCHA folder: NYCHA, via NYC OpenData: https://data.cityofnewyork.us/Housing-Development/NYCHA-Development-Data-Book/evjd-dqpz, https://data.cityofnewyork.us/Housing-Development/Map-of-NYCHA-Developments/i9rv-hdr5

	- OtherHousingAssistance/Section8 folder: US Department of Housing and Urban Development, via https://www.hud.gov/program_offices/housing/mfh/rfp/sec8projbasedconts and https://www.huduser.gov/portal/datasets/assthsg.html

	- PAD folder: NYC Department of City Planning, via https://www1.nyc.gov/site/planning/data-maps/open-data.page

	- pdfs folder: scraped from NYC Department of Finance property-tax bill website, https://a836-pts-access.nyc.gov/care/forms/htmlframe.aspx?mode=content/home.htm

	- tax_schedule/taxrates_byclassyear.dta: 2000--2019 Annual Reports of the New York City Property Tax

	- transactions folder: NYC Department of Finance, via https://www1.nyc.gov/site/finance/taxes/property-annualized-sales-update.page

	- zoning_dist_conversion.dta: see docs/commercial_zoning_data_tables.pdf (original source: https://www1.nyc.gov/assets/planning/download/pdf/zoning/districts-tools/commercial_zoning_data_tables.pdf)



